import requests
import openpyxl

import json
with open('test.json',mode='r',encoding='utf-8')as f:

    l = json.load(fp=f)

# print(l)
for i in json.loads(l.get('content')).get('units'):
    print(i)